Havish M Consulting
Customer Case Study · FLS Attrition Prediction
Life Insurance × Havish M Consulting

Knowing which sellers will leave, 90 days before they do

Front-line sales is where life insurers lose people fastest, often in the first six months. HMC built a Python machine-learning model on a leading life insurer's HR, sales and activity data that scores every front-line seller each month, explains why each one is at risk, and tells managers what to do about it.

SectorLife Insurance FunctionHR · Front-Line Sales ThemeAttrition Prediction · ML in Python
Warning before a seller resigns
0days
▲ scored every month, not at exit
Model accuracy (AUC, held-out test)
0AUC
▲ against about 0.66 for a tenure rule
Leavers caught in the top 20% risk list
0%
▲ managers focus on one in five
Exits in the first six months
0% fewer
▼ after two quarters of action

Figures indicative; validated metrics available on request.

The Challenge

By the time HR heard, the seller had gone

Front-line sales attrition was measured after the fact, explained by exit interviews and treated with one policy for everyone.

Early exits

Most leavers went in their first year, before recovering their hiring and licensing cost.

Lagging signals

Monthly attrition reports told leaders what had already happened.

Data in silos

HRMS, sales MIS, incentive files and CRM logins were never joined at seller level.

One fix for all

Retention spend went to everyone, or to whoever shouted loudest.

HMC Approach

From four data sources to a monthly risk list

Built in Python with HR, sales operations and channel heads; reviewed every month.

Select a step to see what happened.

Discover · Join the seller's story

HRMS, sales MIS, incentive payouts and CRM activity at seller-month level.

  • Three years of joiners and leavers across channels.
  • Exit reasons coded from interviews.
  • Agreed the target: resigns in the next 90 days.

Deliverable: Analytical dataset and data dictionary.

Design · Features managers recognise

Every feature had to be something a manager could act on or explain.

  • Tenure, target achievement, incentive, persistency.
  • Manager changes, training, leaves, CRM logins.
  • Pay against band, commute, channel and zone.

Deliverable: Feature catalogue and leakage checks.

Build · Python models, explained

scikit-learn and LightGBM, explained with SHAP.

  • Logistic regression baseline, gradient boosting final.
  • Time-based validation; calibrated probabilities.
  • Reason codes and a retention action for each seller.

Deliverable: Scoring pipeline and risk desk.

Adopt · Monthly risk review

Agency and bancassurance first.

  • Risk list to branch and area managers on day 3.
  • One action per at-risk seller, tracked to closure.
  • Model refreshed monthly; drift monitored.

Deliverable: Manager playbook.

Scale · Every front-line seller

Direct, tele-sales and partnerships added.

  • Hiring scorecard from the same drivers.
  • Incentive design tested against predicted risk.
  • CHRO and channel head dashboard.

Deliverable: Roll-out plan.

The Solution

Open the attrition lab

A synthetic population of 1,800 past and 420 current front-line sellers. The machine-learning models really train in your browser, mirroring the Python pipeline shown alongside. Drag the 3D charts to turn them.

✦ Add GenAI to the risk desk

Optional. The model and every chart work without a key; retention plans and the CHRO summary come from built-in rules. Add your OpenAI key to have them written for each seller and manager.

Rules
Your key goes only from this browser to OpenAI. Only scores and reason codes are sent.
01 · The data, in three dimensions

Who left, and what they looked like before they did

Each dot is a past seller placed by tenure, target achievement and engagement. Red dots resigned within 90 days. Survival curves show how long each group stays; the hexagon map shows where leavers cluster.

Drag to turn · scroll to zoom · hover a dot
Survival curves

Kaplan–Meier: share still employed by months since joining

Where leavers cluster

Hexbin: tenure × target achievement · colour = share who left · size = sellers

Synthetic data generated to resemble a life insurer's front-line sales force. No real employee data is used.

02 · Model lab

Train two models and compare them

A logistic-regression baseline and a gradient-boosted tree model, trained on 70% of sellers and tested on the other 30%. Change the features or settings and retrain; the Python tab shows the same pipeline as delivered.

Features

ROC curves

True positives against false positives, test set

Learning curve

Gradient boosting log-loss by tree, train and test

Calibration

Predicted risk against actual leaver rate, 10 bins

Confusion matrix at the threshold

Test set, gradient boosting

What drives the prediction

Gradient boosting gain share against logistic-regression standardised coefficient

Models train in JavaScript on the synthetic data so the page runs anywhere; the delivered pipeline runs the Python shown, with LightGBM and SHAP.

03 · Risk desk

Every current seller, scored and explained

Pick a seller to see why the model rates them at risk, try what-if changes, and see their risk landscape in 3D. Then draft the retention plan for their manager.

Rules
SellerChannelZoneTenureTargetRisk
Risk landscape for the selected seller: tenure × target achievement
Drag to turn
Why this risk

Force plot: each reason pushes risk up (red) or down (teal) from the average seller

What if the manager acts?

Move a lever and the model re-scores this seller

The plan uses this seller's top reasons and the what-if result.

04 · Leadership view

Where the next 90 days of exits will come from

Expected leavers by zone and tenure as a 3D city; at-risk sellers grouped into personas by why they are at risk; and the threshold that saves the most money.

Rules
low ratemediumhighheight = expected leavers
Return on retention spend by threshold

Net saving = leavers kept × replacement cost − cost of acting on everyone flagged

At-risk personas

Dendrogram: sellers above the threshold, clustered on their reasons for risk

The summary combines the forecast, personas and the best threshold.

Impact Dashboard

More new sellers reach their first anniversary

With the riskiest sellers reached every month, early exits fell and fewer hiring and licensing costs were written off.

Cohort retention triangle

Share of each joining month still employed, by months since joining

Early exits and their cost

Combo chart: bars = exits within six months of joining (% of joiners); line = cost written off, ₹ lakh

Figures indicative; validated metrics available on request.

Before vs After

How attrition is managed now

DimensionBeforeAfter
When HR knowsOn the resignation emailUp to 90 days earlier, every month
DataHRMS, MIS, incentives and CRM apartOne seller-month dataset
WhyExit interviews, after the factReason codes for each seller
Who actsHR, after escalationThe seller's own manager, with a plan
SpendSame retention offer for everyoneTargeted at the riskiest, at the best threshold
LearningAnnual attrition reviewMonthly model refresh and action tracking
Tools & Tech Used

The attrition model stack

Python · pandas seller-month dataset scikit-learn baseline, pipeline, validation LightGBM gradient-boosted trees SHAP reason codes per seller lifelines survival analysis OpenAI GPT retention plans and summaries Power BI manager risk list
Key Takeaways

What any sales-led business can borrow

01

Predict, then explain

A risk score without reasons gets ignored; reason codes turn it into a manager's to-do.

02

The first six months decide

Onboarding, early targets and a stable manager matter more than pay for new sellers.

03

Pick the threshold with money

Acting on everyone wastes budget; the cost curve shows where retention pays.